﻿/********************************************************************************
* Author:	Christos Polydorou	(xristos.polydoroy@gmail.com)					*
* Author:	Aris Michail		(aris.michail@gmail.com)						*
* Date:		22/9/2011															*
********************************************************************************/

CREATE TABLE [dbo].[Properties]
(
	ID bigint PRIMARY KEY NOT NULL IDENTITY(1,1),
	ProtocolNumber nvarchar(50),
	SignatureDate date,
	ReceivedDate  date,
	PropertySurface float,
	PropertyNomos nvarchar(50),
	PropertyDimos nvarchar(50),
	PropertyArea nvarchar(50),
	OSDENumber bigint,
	AnadasmosNumber bigint,
	RegistrationOffice nvarchar(50),
	OwnerName nvarchar(255),
	OwnerAddress nvarchar(255),
	OwnerTF nvarchar(20),
	FirstSeedDate date,
	FirstSeedSeed float,
	SecondSeedDate date,
	SecondSeedSeed float,
	Apopsigeoponou	nvarchar(255),
	ApopsigeoponouDate date,
	CreatedBy nvarchar(50) NOT NULL,
	LastUpdatedBy nvarchar(50) NOT NULL,
	Coordinates nvarchar(50),
	FirstSeedKodikosSporou nvarchar(20),
	SecondSeedKodikosSporou nvarchar(20)
)
